
DROP TABLE results;

CREATE TABLE results (
 timetaken timestamp,
 code varchar(12) default NULL,
 lang char(5) default NULL,
 interviewer varchar(20) default "online survey",

 gender tinyint UNSIGNED default NULL,
 genderwords varchar(64) default NULL,
 age tinyint UNSIGNED default NULL,
 postalcode varchar(12) default NULL,
 country varchar(2) default NULL,
 
 WSCORE double default NULL,
 SWLscore double default NULL,
 PAFscore double default NULL,

 TBSCORE double default NULL,

 SCVSCORE double default NULL,
 IPTscore double default NULL,
 CPscore double default NULL,
 SSscore double default NULL,

 HEASCORE double default NULL,

 PWSCORE double default NULL,

 MWSCORE double default NULL,
 
 CVSCORE double default NULL,
 ACEscore double default NULL,
 INCscore double default NULL,

 GSCORE double default NULL,
 CGscore double default NULL,
 ICscore double default NULL,
 RFscore double default NULL,

 EVSCORE double default NULL,
 
 SWL1_1 float default -99,
 SWL1_2 float default -99,
 SWL1_3 float default -99,
 SWL1_4 float default -99,
 SWL1_5 float default -99,
 SWL1_6 float default -99,
 PAF1_7 float default -99,
 PAF1_8 float default -99,
 PAF1_9 float default -99,
 PAF1_10 float default -99,
 PAF1_11 float default -99,
 PAF1_12 float default -99,
 PAF1_13 float default -99,
 PAF1_14 float default -99,
 PAF1_15 float default -99,
 PAF1_16 float default -99,
 PAF1_17 float default -99,
 PAF1_18 float default -99,
 PAF1_19 float default -99,
 PAF1_20 float default -99,
 
 TB2_1 float default -99,
 TB2_2 float default -99,
 TB2_3 tinyint default -99,
 TB2_4 tinyint default -99,
 TB2_5 tinyint default -99,
 TB2_6 tinyint default -99,
 TB2_7 tinyint default -99,
 TB2_8 tinyint default -99,
 TB2_9 tinyint default -99,
 TB2_10 float default -99,
 TB2_11 float default -99,
 TB2_12 float default -99,
 TB2_13 float default -99,
 
 IPT3_1 float default -99,
 IPT3_2 float default -99,
 IPT3_3 float default -99,
 IPT3_4 float default -99,
 IPT3_5 float default -99,
 IPT3_6 float default -99,
 IPT3_7 float default -99,
 IPT3_8 float default -99,
 CP3_9 tinyint default -99,
 CP3_10 float default -99,
 CP3_11 tinyint default -99,
 CP3_12 float default -99,
 CP3_13 tinyint default -99,
 CP3_14 float default -99,
 CP3_15 float default -99,
 CP3_16 float default -99,

 SS4_1 float default -99,
 SS4_2 float default -99,
 SS4_3 float default -99,
 SS4_4 float default -99,
 SS4_5 float default -99,
 SS4_6 float default -99,
 SS4_7 float default -99,
 SS4_8 float default -99,
 SS4_9 float default -99,
 SS4_10 float default -99,
 SS4_11 float default -99,
 
 HEA5_1 float default -99,
 HEA5_2 float default -99,
 HEA5_3 tinyint default -99,
 HEA5_4 float default -99,
 HEA5_5 float default -99,
 HEA5_6 tinyint default -99,
 HEA5_7 float default -99,
 HEA5_8 float default -99,
 HEA5_9 float default -99,
 
 PW6_1 float default -99,
 PW6_2 float default -99,
 PW6_3 float default -99,
 PW6_4 float default -99,
 PW6_5 float default -99,
 PW6_6 float default -99,
 PW6_7 float default -99,
 PW6_8 float default -99,
 PW6_9 float default -99,
 PW6_10 float default -99,
 PW6_11 float default -99,
 PW6_12 float default -99,
 
 MW7_1 float default -99,
 MW7_2 float default -99,
 MW7_3 float default -99,
 MW7_4 float default -99,
 MW7_5 float default -99,
 MW7_6 float default -99,
 MW7_7 tinyint default -99,
 MW7_8 tinyint default -99,
 MW7_9 tinyint default -99,
 MW7_10 tinyint default -99,
 MW7_11 float default -99,
 
 ACE8_1 float default -99,
 ACE8_2 float default -99,
 ACE8_3 float default -99,
 ACE8_4 float default -99,
 ACE8_5 float default -99,
 ACE8_6 float default -99,
 ACE8_7 float default -99,
 ACE8_8 float default -99,
 ACE8_9 float default -99,
 ACE8_10 float default -99,
 INC8_11 float default -99,
 INC8_12 float default -99,
 INC8_13 float default -99,
 INC8_14 float default -99,
 INC8_15 float default -99,
 
 CG9_1 float default -99,
 CG9_2 float default -99,
 CG9_3 float default -99,
 CG9_4 float default -99,
 CG9_5 float default -99,
 CG9_6 float default -99,
 CG9_7 float default -99,
 CG9_8 float default -99,
 IC9_9 float default -99,
 IC9_10 float default -99,
 IC9_11 float default -99,
 IC9_12 float default -99,
 IC9_13 float default -99,
 IC9_14 float default -99,
 IC9_15 float default -99,
 IC9_16 float default -99,
 IC9_17 float default -99,
 IC9_18 float default -99,
 RF9_19 float default -99,
 RF9_20 float default -99,
 RF9_21 float default -99,
 RF9_22 float default -99,
 RF9_23 float default -99,
 RF9_24 float default -99,
 
 EV10_1 float default -99,
 EV10_2 float default -99,
 EV10_3 float default -99,
 EV10_4 float default -99,
 EV10_5 float default -99,
 EV10_6 float default -99,

 racewhite bool default 0,
 racehispanic bool default 0,
 raceblack bool default 0,
 racenative bool default 0,
 raceindia bool default 0,
 racechinese bool default 0,
 racefilipino bool default 0,
 raceasianother bool default 0,
 racejapanese bool default 0,
 racekorean bool default 0,
 racevietnamese bool default 0,
 racehawaiian bool default 0,
 raceguamchamorro bool default 0,
 racesamoan bool default 0,
 racepacificother bool default 0,
 raceother bool default 0,
 racewords varchar(128) default NULL,
 racecount tinyint default 0,

 maritalstatus tinyint UNSIGNED default NULL,
 edlevel tinyint UNSIGNED default NULL,
 householdsize tinyint UNSIGNED default NULL,
 hhtype tinyint UNSIGNED default NULL,
 income tinyint UNSIGNED default NULL,
 
 canwecontact bool default 0,
 email varchar(32) default NULL
 
) TYPE=MyISAM;